﻿CREATE VIEW [dbo].[MembersInCourse]
	AS 
	
	SELECT Student.MemberID, Members.FirstName, Members.LastName, StudentCourse.Grade 
	FROM Student
	JOIN StudentCourse ON Student.ID = StudentCourse.StudentId
	JOIN DoctorInCourses ON StudentCourse.CourseSemesterId = DoctorInCourses.ID
	JOIN Courses ON DoctorInCourses.CoursesID = Courses.ID
	join Members ON Student.MemberID = Members.Id
